The Month, Day, and Year functions can all be used in examples like the following:
Selects those records in which the year found in the {file.DATE} field is earlier than 1999.
Year ({file.DATE}) > 1992 and Year ({file.DATE}) < 1996Selects those records in which the year found in the {file.DATE} field falls between 1992 and 1996 (1992 and 1996 not included).
Year({file.DATE}) >= 1992 and Year({file.DATE}) <= 1996Selects those records in which the year found in the {file.DATE} field falls between 1992 and 1996 (1992 and 1996 are included).
Selects those records in which the month found in the {file.DATE} field is one of the first four months of the year (includes January, February, March, and April).
Selects those records in which the month found in the {file.DATE} field is the first or fourth month of the year (includes January and April, excludes February and March).
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |